<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10" interactivePageBreakByFrame="true"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-3-30. 16:23:32-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							
						<pageSet name="ESX Host1" refQuery="Report ETL - Current">
			<detailPages><page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles><CSS value="width:13.5in"/></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>ESX Subscription Impact - Historical Analysis</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><list showColumnTitles="hide" refQuery="Report ETL - Current" name="List1">
			<listColumns>
				<listColumn>
					<listColumnTitle>
						<contents/>
					</listColumnTitle>
					<listColumnBody>
						<contents><list horizontalPagination="true" name="List2" refQuery="Report ETL - Current">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;border:1pt solid #F7F7F7"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none;border:1pt solid #F7F7F7"/></style><contents><textItem><dataSource><staticValue>Subscription Detail</staticValue></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="border:1pt solid #F7F7F7"/></style><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>ESX Highlights</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-bottom:5px;border-bottom:1.5pt solid silver"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>ESX Memory GB: </staticValue></dataSource><style><CSS value="font-size:14px;color:#454545"/></style></textItem></contents><style><CSS value="padding-right:15px"/></style></tableCell><tableCell><contents><repeater name="Repeater2" refQuery="Report ETL - Current">
			<contents><textItem><dataSource><dataItemValue refDataItem="Memory GB"/></dataSource><style><CSS value="font-size:14px;color:#454545"/></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="ESX Host"/></masterContext><detailContext><parameterContext parameter="sESX"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents><style><CSS value="text-align:right"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>ESX CPU Count:</staticValue></dataSource><style><CSS value="font-size:14px;color:#454545"/></style></textItem></contents><style><CSS value="padding-right:15px"/></style></tableCell><tableCell><contents><repeater name="Repeater3" refQuery="Report ETL - Current">
			<contents><textItem><dataSource><dataItemValue refDataItem="CPU Count"/></dataSource><style><CSS value="font-size:14px;color:#454545"/></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="ESX Host"/></masterContext><detailContext><parameterContext parameter="sESX"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents><style><CSS value="text-align:right"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Allocated CPU Count:</staticValue></dataSource><style><CSS value="font-size:14px;color:#454545"/></style></textItem></contents><style><CSS value="padding-right:15px"/></style></tableCell><tableCell><contents><repeater name="Repeater4" refQuery="Report ETL - Current">
			<contents><textItem><dataSource><dataItemValue refDataItem="Allocated CPU Count"/></dataSource><style><CSS value="font-size:14px;color:#454545"/></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="ESX Host"/></masterContext><detailContext><parameterContext parameter="sESX"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents><style><CSS value="text-align:right"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Allocated Memory GB: </staticValue></dataSource><style><CSS value="font-size:14px;color:#454545"/></style></textItem></contents><style><CSS value="padding-right:15px"/></style></tableCell><tableCell><contents><repeater name="Repeater5" refQuery="Report ETL - Current">
			<contents><textItem><dataSource><dataItemValue refDataItem="Allocated Memory GB"/></dataSource><style><CSS value="font-size:14px;color:#454545"/></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="ESX Host"/></masterContext><detailContext><parameterContext parameter="sESX"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents><style><CSS value="text-align:right"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Memory Subscriptiion %: </staticValue></dataSource><style><CSS value="font-size:14px;color:#454545"/></style></textItem></contents><style><CSS value="padding-right:15px"/></style></tableCell><tableCell><contents><repeater name="Repeater6" refQuery="Report ETL - Current">
			<contents><textItem><dataSource><dataItemValue refDataItem="Memory Subscription %"/></dataSource><style><CSS value="font-size:14px;color:#454545"/><dataFormat><percentFormat/></dataFormat></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="List-MemorySubscription"/></conditionalStyleRefs></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="ESX Host"/></masterContext><detailContext><parameterContext parameter="sESX"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents><style><CSS value="text-align:right"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>CPU Subscription %: </staticValue></dataSource><style><CSS value="font-size:14px;color:#454545"/></style></textItem></contents><style><CSS value="padding-right:15px"/></style></tableCell><tableCell><contents><repeater name="Repeater7" refQuery="Report ETL - Current">
			<contents><textItem><dataSource><dataItemValue refDataItem="CPU Subscription %"/></dataSource><style><CSS value="font-size:14px;color:#454545"/><dataFormat><percentFormat/></dataFormat></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="List-CPUSubscription"/></conditionalStyleRefs></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="ESX Host"/></masterContext><detailContext><parameterContext parameter="sESX"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents><style><CSS value="text-align:right"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>VM Count: </staticValue></dataSource><style><CSS value="font-size:14px;color:#454545"/></style></textItem></contents><style><CSS value="padding-right:15px"/></style></tableCell><tableCell><contents><repeater name="Repeater1" refQuery="Top Consumers CPU - VM Guests">
			<contents><textItem><dataSource><dataItemValue refDataItem="VM Count"/></dataSource><style><CSS value="font-size:14px;color:#454545"/></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="ESX Host"/></masterContext><detailContext><parameterContext parameter="sESX"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents><style><CSS value="text-align:right"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Capacity in Datastores:</staticValue></dataSource><style><CSS value="font-size:14px;color:#454545"/></style></textItem></contents><style><CSS value="padding-right:15px"/></style></tableCell><tableCell><contents><repeater name="Repeater8" refQuery="ESX Capacities">
			<contents><textItem><dataSource><dataItemValue refDataItem="Capacity (GB)"/></dataSource><style><CSS value="font-size:14px;color:#454545"/><dataFormat><numberFormat pattern="###,###' GB'"/></dataFormat></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="ESX Host"/></masterContext><detailContext><parameterContext parameter="sESX"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents><style><CSS value="text-align:right"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Provisioned:</staticValue></dataSource><style><CSS value="font-size:14px;color:#454545"/></style></textItem></contents><style><CSS value="padding-right:15px"/></style></tableCell><tableCell><contents><repeater name="Repeater9" refQuery="ESX Capacities">
			<contents><textItem><dataSource><dataItemValue refDataItem="Provisioned (GB)"/></dataSource><style><CSS value="font-size:14px;color:#454545"/><dataFormat><numberFormat pattern="###,###' GB'"/></dataFormat></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="ESX Host"/></masterContext><detailContext><parameterContext parameter="sESX"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents><style><CSS value="text-align:right"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Used:</staticValue></dataSource><style><CSS value="font-size:14px;color:#454545"/></style></textItem></contents><style><CSS value="padding-right:15px"/></style></tableCell><tableCell><contents><repeater name="Repeater10" refQuery="ESX Capacities">
			<contents><textItem><dataSource><dataItemValue refDataItem="Used (GB)"/></dataSource><style><CSS value="font-size:14px;color:#454545"/><dataFormat><numberFormat pattern="###,###' GB'"/></dataFormat></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="ESX Host"/></masterContext><detailContext><parameterContext parameter="sESX"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents><style><CSS value="text-align:right"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Used %:</staticValue></dataSource><style><CSS value="font-size:14px;color:#454545"/></style></textItem></contents><style><CSS value="padding-right:15px"/></style></tableCell><tableCell><contents><repeater name="Repeater11" refQuery="ESX Capacities">
			<contents><textItem><dataSource><dataItemValue refDataItem="% Used"/></dataSource><style><CSS value="font-size:14px;color:#454545"/><dataFormat><percentFormat/></dataFormat></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="% Data Store Used"/></conditionalStyleRefs></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="ESX Host"/></masterContext><detailContext><parameterContext parameter="sESX"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents><style><CSS value="text-align:right"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:5px;padding-top:5px;padding-bottom:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Volume IOpS</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(14 Day Average)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="Vol Perf" name="Combination Chart8" depth="9">
																										<v2_combinationTypeTooltips/>
																										<v2_commonAxis>
																											<v2_ordinalAxis autoTruncation="false" truncationText="..." manualTruncationMaxChars="15">
																												<v2_axisLabels>
																													<style>
																														<defaultStyles>
																															<defaultStyle refStyle="al"/>
																														</defaultStyles>
																													<CSS value="color:#454545"/></style>
																												</v2_axisLabels>
																											</v2_ordinalAxis>
																											<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Volume"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																										<v2_topLeftAxis>
																											<v2_combinationChartTypes>
																												<v2_bar borders="hide" setOrdinalWidthScale="80" bevel="none" borderColor="black" barShape="box">
																													<v2_solidPalette>
																														<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="totaliops"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat decimalSize="0"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/></v2_bar>
																											</v2_combinationChartTypes>
																											<v2_axis>
																												<v2_axisRange scale="linear">
																													<v2_automaticRange sameRangeAllInstances="false" includeZeroForAutoScale="true"/>
																												</v2_axisRange>
																												<v2_axisLabels>
																													<style>
																														<defaultStyles>
																															<defaultStyle refStyle="al"/>
																														</defaultStyles>
																														<dataFormat><numberFormat pattern="###,###' IOs'"/></dataFormat><CSS value="color:#454545"/></style>
																												</v2_axisLabels>
																												<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/></v2_axis>
																										</v2_topLeftAxis>
																										<style>
																											<CSS value="width:300px;height:222.5px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																										
																										<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="ESX Host"/></masterContext><detailContext><parameterContext parameter="sESX"/></detailContext></masterDetailLink></masterDetailLinks></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Volume Latency</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(14 Day Average)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="Vol Perf" name="Combination Chart9" depth="9">
	<v2_combinationTypeTooltips/>
	<v2_commonAxis>
		<v2_ordinalAxis autoTruncation="false" truncationText="..." manualTruncationMaxChars="15">
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
				<CSS value="color:#454545"/></style>
			</v2_axisLabels>
		</v2_ordinalAxis>
		<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Volume"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
	<v2_topLeftAxis>
		<v2_combinationChartTypes>
			<v2_bar borders="hide" setOrdinalWidthScale="80" bevel="none" borderColor="black" barShape="box">
				<v2_solidPalette>
																														<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="latency"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat decimalSize="1"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
		</v2_combinationChartTypes>
		<v2_axis>
			<v2_axisRange scale="linear">
				<v2_automaticRange sameRangeAllInstances="false" includeZeroForAutoScale="true"/>
			</v2_axisRange>
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
					<dataFormat><numberFormat pattern="###.#' ms'"/></dataFormat><CSS value="color:#454545"/></style>
			</v2_axisLabels>
			<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/></v2_axis>
	</v2_topLeftAxis>
	<style>
		<CSS value="width:300px;height:222.5px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
	
	<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="ESX Host"/></masterContext><detailContext><parameterContext parameter="sESX"/></detailContext></masterDetailLink></masterDetailLinks></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none;border:1pt solid #F7F7F7"/></style><contents><textItem><dataSource><staticValue>Trends</staticValue></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="border:1pt solid #F7F7F7"/></style><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>CPU and Memory Subscription Trends and Performance Snapshot</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><v2_combinationChart maxHotspots="10000" refQuery="Report ETL" name="Combination Chart1">
																																												<v2_combinationTypeTooltips/>
																																												<v2_commonAxis>
																																													<v2_ordinalAxis>
																																														<v2_axisLabels>
																																															<style>
																																																<defaultStyles>
																																																	<defaultStyle refStyle="al"/>
																																																</defaultStyles>
																																																<CSS value="color:#454545"/></style>
																																														</v2_axisLabels>
																																													</v2_ordinalAxis>
																																													<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat showYears="false" showMonths="shortName" showDays="1-digit"/></dataFormat></style><sortList><sortItem refDataItem="Date"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																												<v2_topLeftAxis>
																																													<v2_combinationChartTypes>
																																														<v2_line lineAreaShape="smooth">
																																															<v2_linePalette markerSize="5pt">
																												<v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#88B2D3"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#FFB2C1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="CPU Subscription %"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line>
																																													</v2_combinationChartTypes>
																																													<v2_axis>
																																														<v2_axisRange scale="linear">
																
															<v2_specifiedRange includeZeroForAutoScale="true" min="0"/></v2_axisRange><v2_axisLabels>
																<style>
																	<defaultStyles>
																		<defaultStyle refStyle="al"/>
																	</defaultStyles>
																	<dataFormat><percentFormat/></dataFormat><CSS value="color:#454545"/></style>
																</v2_axisLabels><v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/></v2_axis>
																																												</v2_topLeftAxis>
																																												<style>
																																													<CSS value="width:450px;height:165px;border:1pt solid silver"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																												<noDataHandler>
																																													<contents>
																																														<block>
																																															<contents>
																																																<textItem>
																																																	<dataSource>
																																																		<staticValue>No Data Available</staticValue>
																																																	</dataSource>
																																																	<style>
																																																		<CSS value="padding:10px 18px;"/>
																																																	</style>
																																																</textItem>
																																															</contents>
																																														</block>
																																													</contents>
																																												</noDataHandler>
																																												<v2_chartTitle refQuery="Report ETL"><style><defaultStyles><defaultStyle refStyle="ct"/></defaultStyles><CSS value="text-align:left;color:gray;font-size:10pt"/></style><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>CPU Subscription % Trend</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems></v2_chartTitle><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="ESX Host"/></masterContext><detailContext><parameterContext parameter="sESX"/></detailContext></masterDetailLink></masterDetailLinks><v2_notes><v2_note refQuery="Report ETL"><v2_chartTextItems><v2_chartTextItem><dataSource><dataItemValue refDataItem="CPU Subscription % Latest"/></dataSource><style><dataFormat><percentFormat/></dataFormat></style></v2_chartTextItem></v2_chartTextItems><style><CSS value="font-family:Arial;font-size:16px;font-weight:bold;color:#808080"/></style><v2_constrainedPosition><v2_verticalPosition><v2_top offset="-10px"/></v2_verticalPosition><v2_horizontalPosition><v2_right offset="-10px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 1"/></conditionalStyleRefs></v2_note></v2_notes></v2_combinationChart>
																						</contents><style><CSS value="padding-top:5px"/></style></tableCell><tableCell><contents><v2_combinationChart maxHotspots="10000" refQuery="Report ETL" name="Combination Chart2">
																																												<v2_combinationTypeTooltips/>
																																												<v2_commonAxis>
																																													<v2_ordinalAxis>
																																														<v2_axisLabels>
																																															<style>
																																																<defaultStyles>
																																																	<defaultStyle refStyle="al"/>
																																																</defaultStyles>
																																																<CSS value="color:#454545"/></style>
																																														</v2_axisLabels>
																																													</v2_ordinalAxis>
																																													<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat showYears="false" showMonths="shortName" showDays="1-digit"/></dataFormat></style><sortList><sortItem refDataItem="Date"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																												<v2_topLeftAxis>
																																													<v2_combinationChartTypes>
																																														<v2_line lineAreaShape="smooth">
																																															<v2_linePalette markerSize="5pt">
																												<v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#88B2D3"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#FFB2C1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Memory Subscription %"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line>
																																													</v2_combinationChartTypes>
																																													<v2_axis>
																																														<v2_axisRange scale="linear">
				
			<v2_specifiedRange includeZeroForAutoScale="true" min="0" max="1"/></v2_axisRange><v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
					<dataFormat><percentFormat/></dataFormat><CSS value="color:#454545"/></style>
			</v2_axisLabels><v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/></v2_axis>
																																												</v2_topLeftAxis>
																																												<style>
																																													<CSS value="width:450px;height:165px;border:1pt solid silver"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																												<noDataHandler>
																																													<contents>
																																														<block>
																																															<contents>
																																																<textItem>
																																																	<dataSource>
																																																		<staticValue>No Data Available</staticValue>
																																																	</dataSource>
																																																	<style>
																																																		<CSS value="padding:10px 18px;"/>
																																																	</style>
																																																</textItem>
																																															</contents>
																																														</block>
																																													</contents>
																																												</noDataHandler>
																																												<v2_chartTitle refQuery="Report ETL"><style><defaultStyles><defaultStyle refStyle="ct"/></defaultStyles><CSS value="color:gray;font-size:10pt;text-align:left"/></style><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>Memory Subscription % Trend</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems></v2_chartTitle><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="ESX Host"/></masterContext><detailContext><parameterContext parameter="sESX"/></detailContext></masterDetailLink></masterDetailLinks><v2_notes><v2_note refQuery="Report ETL"><v2_chartTextItems><v2_chartTextItem><dataSource><dataItemValue refDataItem="Memory Subscription % Latest"/></dataSource><style><dataFormat><percentFormat/></dataFormat></style></v2_chartTextItem></v2_chartTextItems><style><CSS value="font-family:Arial;font-size:16px;font-weight:bold;color:#808080"/></style><v2_constrainedPosition><v2_verticalPosition><v2_top offset="-10px"/></v2_verticalPosition><v2_horizontalPosition><v2_right offset="-10px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 2"/></conditionalStyleRefs></v2_note></v2_notes></v2_combinationChart>
																						</contents><style><CSS value="padding-left:5px;padding-top:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell colSpan="2"><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart4" refQuery="ESX Perf ETL">
													<v2_combinationTypeTooltips/>
													<v2_commonAxis>
														<v2_ordinalAxis>
															<v2_axisLabels>
																<style>
																	<defaultStyles>
																		<defaultStyle refStyle="al"/>
																	</defaultStyles>
																<CSS value="color:#454545"/></style>
															</v2_axisLabels>
														<v2_labelControl/></v2_ordinalAxis>
														<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="time"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="time"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateTimeFormat showYears="false" showMonths="shortName" showDays="1-digit" showAmPm="false" showHours="false" showMinutes="false" showSeconds="false" showMilliseconds="false"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
													<v2_topLeftAxis>
														<v2_combinationChartTypes>
															<v2_area seriesType="stacked" borderColor="#000099">
																<v2_solidPalette>
																	<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="totaliops"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_area>
														</v2_combinationChartTypes>
														<v2_axis>
															<v2_axisRange scale="linear">
																<v2_automaticRange sameRangeAllInstances="false" includeZeroForAutoScale="true"/>
															</v2_axisRange>
															<v2_axisLabels>
																<style>
																	<defaultStyles>
																		<defaultStyle refStyle="al"/>
																	</defaultStyles>
																	<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' IOs'"/></dataFormat></style>
																</v2_axisLabels>
															
														<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/></v2_axis>
													</v2_topLeftAxis>
													<style>
														<defaultStyles>
															<defaultStyle refStyle="ch"/>
														</defaultStyles>
														<CSS value="width:297.5px;height:125px;border:1pt solid silver"/></style>
													<noDataHandler>
														<contents>
															<block>
																<contents>
																	<textItem>
																		<dataSource>
																			<staticValue>No Data Available</staticValue>
																		</dataSource>
																		<style>
																			<CSS value="padding:10px 18px;"/>
																		</style>
																	</textItem>
																</contents>
															</block>
														</contents>
													</noDataHandler>
													<v2_chartTitle refQuery="ESX Perf ETL"><style><defaultStyles><defaultStyle refStyle="ct"/></defaultStyles><CSS value="text-align:left;color:gray;font-size:10pt"/></style><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>ESX Total IOpS (Read+Write)</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems></v2_chartTitle><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="ESX Host"/></masterContext><detailContext><parameterContext parameter="sESX"/></detailContext></masterDetailLink></masterDetailLinks></v2_combinationChart></contents></tableCell><tableCell><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart3" refQuery="ESX Perf ETL">
													<v2_combinationTypeTooltips/>
													<v2_commonAxis>
														<v2_ordinalAxis>
															<v2_axisLabels>
																<style>
																	<defaultStyles>
																		<defaultStyle refStyle="al"/>
																	</defaultStyles>
																<CSS value="color:#454545"/></style>
															</v2_axisLabels>
														<v2_labelControl/></v2_ordinalAxis>
														<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="time"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="time"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateTimeFormat showYears="false" showMonths="shortName" showDays="1-digit" showAmPm="false" showHours="false" showMinutes="false" showSeconds="false" showMilliseconds="false"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
													<v2_topLeftAxis>
														<v2_combinationChartTypes>
															<v2_area seriesType="absolute" borderColor="#000099">
																<v2_solidPalette>
																	<v2_solidPaletteEntries><v2_solidPaletteEntry>
																																						<v2_fillEffect defaultColor="#0084e3">
																																							<v2_solidColor color="#88B2D3" transparency="0"/>
																																						</v2_fillEffect>
																																					</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																						<v2_fillEffect defaultColor="#999999">
																																							<v2_solidColor color="#999999" transparency="60"/>
																																						</v2_fillEffect>
																																					</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																						<v2_fillEffect defaultColor="#000066">
																																							<v2_solidColor color="#000066"/>
																																						</v2_fillEffect>
																																					</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																						<v2_fillEffect defaultColor="#99CCFF">
																																							<v2_solidColor color="#99CCFF"/>
																																						</v2_fillEffect>
																																					</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																						<v2_fillEffect defaultColor="#336699">
																																							<v2_solidColor color="#336699"/>
																																						</v2_fillEffect>
																																					</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																						<v2_fillEffect defaultColor="#F3F3F3">
																																							<v2_solidColor color="#F3F3F3"/>
																																						</v2_fillEffect>
																																					</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																						<v2_fillEffect defaultColor="#E7E7E7">
																																							<v2_solidColor color="#E7E7E7"/>
																																						</v2_fillEffect>
																																					</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																						<v2_fillEffect defaultColor="#99AACC">
																																							<v2_solidColor color="#99AACC"/>
																																						</v2_fillEffect>
																																					</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																						<v2_fillEffect defaultColor="#E3E9F3">
																																							<v2_solidColor color="#E3E9F3"/>
																																						</v2_fillEffect>
																																					</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																						<v2_fillEffect defaultColor="#CCCCCC">
																																							<v2_solidColor color="#CCCCCC"/>
																																						</v2_fillEffect>
																																					</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="AverageCPUUtilization"><chartContents><chartTextItem><dataSource><staticValue>Avg CPU %</staticValue></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="AverageMemoryUtilization"><chartContents><chartTextItem><dataSource><staticValue>Avg Memory %</staticValue></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_area>
														</v2_combinationChartTypes>
														<v2_axis>
															<v2_axisRange scale="linear">
																<v2_automaticRange sameRangeAllInstances="false" includeZeroForAutoScale="true"/>
															</v2_axisRange>
															<v2_axisLabels>
																<style>
																	<defaultStyles>
																		<defaultStyle refStyle="al"/>
																	</defaultStyles>
																	<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###.#' %'"/></dataFormat></style>
																</v2_axisLabels>
															
														<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/></v2_axis>
													</v2_topLeftAxis>
													<style>
														<defaultStyles>
															<defaultStyle refStyle="ch"/>
														</defaultStyles>
														<CSS value="width:297.5px;height:125px;border:1pt solid silver"/></style>
													<noDataHandler>
														<contents>
															<block>
																<contents>
																	<textItem>
																		<dataSource>
																			<staticValue>No Data Available</staticValue>
																		</dataSource>
																		<style>
																			<CSS value="padding:10px 18px;"/>
																		</style>
																	</textItem>
																</contents>
															</block>
														</contents>
													</noDataHandler>
													<v2_chartTitle refQuery="ESX Perf ETL"><style><defaultStyles><defaultStyle refStyle="ct"/></defaultStyles><CSS value="text-align:left;color:gray;font-size:10pt"/></style><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>ESX Memory and CPU Utilization %</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems></v2_chartTitle><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="ESX Host"/></masterContext><detailContext><parameterContext parameter="sESX"/></detailContext></masterDetailLink></masterDetailLinks><v2_legend><style><defaultStyles><defaultStyle refStyle="lg"/></defaultStyles><CSS value="color:#454545"/></style><v2_legendPosition><v2_legendPreset legendPositionPreset="bottom"/></v2_legendPosition></v2_legend></v2_combinationChart></contents><style><CSS value="padding-left:5px"/></style></tableCell><tableCell><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart5" refQuery="ESX Perf ETL">
													<v2_combinationTypeTooltips/>
													<v2_commonAxis>
														<v2_ordinalAxis>
															<v2_axisLabels>
																<style>
																	<defaultStyles>
																		<defaultStyle refStyle="al"/>
																	</defaultStyles>
																<CSS value="color:#454545"/></style>
															</v2_axisLabels>
														<v2_labelControl/></v2_ordinalAxis>
														<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="time"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="time"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateTimeFormat showYears="false" showMonths="shortName" showDays="1-digit" showAmPm="false" showHours="false" showMinutes="false" showSeconds="false" showMilliseconds="false"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
													<v2_topLeftAxis>
														<v2_combinationChartTypes>
															<v2_area seriesType="stacked" borderColor="#000099">
																<v2_solidPalette>
																	<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="latency"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_area>
														</v2_combinationChartTypes>
														<v2_axis>
															<v2_axisRange scale="linear">
																<v2_automaticRange sameRangeAllInstances="false" includeZeroForAutoScale="true"/>
															</v2_axisRange>
															<v2_axisLabels>
																<style>
																	<defaultStyles>
																		<defaultStyle refStyle="al"/>
																	</defaultStyles>
																	<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###.#' ms'"/></dataFormat></style>
																</v2_axisLabels>
															
														<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/></v2_axis>
													</v2_topLeftAxis>
													<style>
														<defaultStyles>
															<defaultStyle refStyle="ch"/>
														</defaultStyles>
														<CSS value="width:297.5px;height:125px;border:1pt solid silver"/></style>
													<noDataHandler>
														<contents>
															<block>
																<contents>
																	<textItem>
																		<dataSource>
																			<staticValue>No Data Available</staticValue>
																		</dataSource>
																		<style>
																			<CSS value="padding:10px 18px;"/>
																		</style>
																	</textItem>
																</contents>
															</block>
														</contents>
													</noDataHandler>
													<v2_chartTitle refQuery="ESX Perf ETL"><style><defaultStyles><defaultStyle refStyle="ct"/></defaultStyles><CSS value="text-align:left;color:gray;font-size:10pt"/></style><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>ESX Latency (ms)</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems></v2_chartTitle><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="ESX Host"/></masterContext><detailContext><parameterContext parameter="sESX"/></detailContext></masterDetailLink></masterDetailLinks></v2_combinationChart></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px;vertical-align:top"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell colSpan="2"><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents>
																												</contents></tableCell><tableCell><contents/><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart10" refQuery="VM Perf" depth="9">
																														<v2_combinationTypeTooltips/>
																														<v2_commonAxis>
																															<v2_ordinalAxis>
																																<v2_axisLabels>
																																	<style>
																																		<defaultStyles>
																																			<defaultStyle refStyle="al"/>
																																		</defaultStyles>
																																	<CSS value="color:#454545"/></style>
																																</v2_axisLabels>
																															</v2_ordinalAxis>
																															<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="VMGuest"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="AverageCPUUtilization"/></sortList><propertyList><propertyItem refDataItem="VM Count"/></propertyList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																														<v2_topLeftAxis>
																															<v2_combinationChartTypes>
																																<v2_bar barShape="box" setOrdinalWidthScale="60">
																																	<v2_solidPalette>
																																		<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																																	<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="AverageCPUUtilization"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																															</v2_combinationChartTypes>
																															<v2_axis>
																																<v2_axisRange scale="linear">
																																	<v2_automaticRange sameRangeAllInstances="false" includeZeroForAutoScale="true"/>
																																</v2_axisRange>
																																<v2_axisLabels>
																																	<style>
																																		<defaultStyles>
																																			<defaultStyle refStyle="al"/>
																																		</defaultStyles>
																																		<dataFormat><numberFormat pattern="###' %'"/></dataFormat><CSS value="color:#454545"/></style>
																																</v2_axisLabels>
																																<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
																															</v2_axis>
																														</v2_topLeftAxis>
																														<style>
																															<defaultStyles>
																																<defaultStyle refStyle="ch"/>
																															</defaultStyles>
																															<CSS value="width:450px;height:200px;color:#454545;border:1pt solid silver"/></style>
																														<noDataHandler>
																															<contents>
																																<block>
																																	<contents>
																																		<textItem>
																																			<dataSource>
																																				<staticValue>No Data Available</staticValue>
																																			</dataSource>
																																			<style>
																																				<CSS value="padding:10px 18px;"/>
																																			</style>
																																		</textItem>
																																	</contents>
																																</block>
																															</contents>
																														</noDataHandler>
																														<v2_chartTitle refQuery="VM Perf"><style><defaultStyles><defaultStyle refStyle="ct"/></defaultStyles><CSS value="color:gray;font-size:10pt;text-align:left"/></style><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>VM CPU Utilization %</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems></v2_chartTitle><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="ESX Host"/></masterContext><detailContext><parameterContext parameter="sESX"/></detailContext></masterDetailLink></masterDetailLinks><conditionalRender refVariable="vmCountMoreThan30"><renderFor refVariableValue="1"/></conditionalRender></v2_combinationChart></contents><style><CSS value="padding-bottom:5px"/></style></tableCell><tableCell><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart11" refQuery="VM Perf" depth="9">
	<v2_combinationTypeTooltips/>
	<v2_commonAxis>
		<v2_ordinalAxis>
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
				<CSS value="color:#454545"/></style>
			</v2_axisLabels>
		</v2_ordinalAxis>
		<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="VMGuest"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="latency"/></sortList><propertyList><propertyItem refDataItem="VM Count"/></propertyList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
	<v2_topLeftAxis>
		<v2_combinationChartTypes>
			<v2_bar barShape="box" setOrdinalWidthScale="60">
				<v2_solidPalette>
					<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
				<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="latency"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###.#"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
		</v2_combinationChartTypes>
		<v2_axis>
			<v2_axisRange scale="log">
				<v2_automaticRange sameRangeAllInstances="false" includeZeroForAutoScale="true"/>
			</v2_axisRange>
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
				<dataFormat><numberFormat pattern="###.##' ms'"/></dataFormat><CSS value="color:#454545"/></style>
			</v2_axisLabels>
			<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
		</v2_axis>
	</v2_topLeftAxis>
	<style>
		<defaultStyles>
			<defaultStyle refStyle="ch"/>
		</defaultStyles>
		<CSS value="width:450px;height:200px;color:#454545;border:1pt solid silver"/></style>
	<noDataHandler>
		<contents>
			<block>
				<contents>
					<textItem>
						<dataSource>
							<staticValue>No Data Available</staticValue>
						</dataSource>
						<style>
							<CSS value="padding:10px 18px;"/>
						</style>
					</textItem>
				</contents>
			</block>
		</contents>
	</noDataHandler>
	<v2_chartTitle refQuery="VM Perf"><style><defaultStyles><defaultStyle refStyle="ct"/></defaultStyles><CSS value="color:gray;font-size:10pt;text-align:left"/></style><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>VM Latency (ms)</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems></v2_chartTitle><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="ESX Host"/></masterContext><detailContext><parameterContext parameter="sESX"/></detailContext></masterDetailLink></masterDetailLinks><conditionalRender refVariable="vmCountMoreThan30"><renderFor refVariableValue="1"/></conditionalRender></v2_combinationChart></contents><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="text-align:center;padding-top:5px;vertical-align:top"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell colSpan="2"><contents/><style><CSS value="text-align:center;padding-top:5px;vertical-align:top"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Storage Inventory Detail Supporting this ESX Server</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><block>
			<contents><list horizontalPagination="true" name="List3" refQuery="ESX Capacities" rowsPerPage="1000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Volume"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Volume"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Capacity GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Capacity GB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Data Store"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Data Store"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Capacity (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Capacity (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Thin Subscribed%"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Thin Subscribed%"/></dataSource></textItem></contents><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Thin Subscribed %"/></conditionalStyleRefs></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Provisioned (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Provisioned (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Used (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="% Used"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="% Used"/></dataSource></textItem></contents><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="% Data Store Used"/></conditionalStyleRefs></listColumnBody></listColumn></listColumns><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="ESX Host"/></masterContext><detailContext><parameterContext parameter="sESX"/></detailContext></masterDetailLink></masterDetailLinks></list></contents>
		<style><CSS value="width:100%;height:150px;overflow:auto"/></style></block></contents><style><CSS value="text-align:center;padding-top:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></listColumnBody></listColumn></listColumns></list></contents>
						<style>
							<defaultStyles>
								<defaultStyle refStyle="sb"/>
							</defaultStyles>
						</style>
					</listColumnBody>
				</listColumn>
			</listColumns>
			
			
			
			<style>
				<CSS value="border-collapse:collapse;width:100%;border:1pt solid #F7F7F7"/>
				<defaultStyles>
					<defaultStyle refStyle="sc"/>
				</defaultStyles>
			</style>
		<listGroups><listGroup refDataItem="ESX Host"><listHeader><listRows><listRow><rowCells><rowCell><contents><textItem><dataSource><dataItemLabel refDataItem="ESX Host"/></dataSource></textItem><textItem><dataSource><staticValue>: </staticValue></dataSource></textItem><textItem><dataSource><dataItemValue refDataItem="ESX Host"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="sh"/></defaultStyles><CSS value="font-size:14pt;color:#808080;border:1pt solid #F7F7F7"/></style></rowCell></rowCells></listRow></listRows></listHeader><XMLAttributes><XMLAttribute name="RS_SectionedEdge" value="columns" output="no"/></XMLAttributes></listGroup></listGroups><sectionsFrame refFrame="List2" sectionedEdge="columns"/></list></contents><style><CSS value="padding:10px;height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							<pageSetup orientation="portrait"><customPaper width="15" height="11" unit="in"/></pageSetup></page></detailPages>
		<pageGroups><pageGroup refDataItem="ESX Host"/></pageGroups></pageSet></reportPages>
					<promptPages><page name="Prompt Page1">
			
			<pageBody>
				<contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;padding-left:24px;background-color:#6198C5"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>ESX Subscription Impact - Historical Analysis</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:24px;color:#333333"/></style></textItem></contents><style><CSS value="height:36px;background-color:#FBFBFB;padding-left:24px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;margin-top:50px;margin-left:50px"/></style><tableRows><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents><textItem><dataSource><staticValue>Select ESX Server(s):</staticValue></dataSource><style><CSS value="color:#333333;font-weight:bold"/></style></textItem></contents><style><CSS value="background-color:#8DB4E2;padding-left:10px"/></style></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents><selectValue parameter="sESX" refQuery="sESX Prompt" required="false" multiSelect="true" selectValueUI="checkboxGroup"><useItem refDataItem="ESX Server"/><style><CSS value="width:175px;height:450px"/></style></selectValue></contents><style><CSS value="padding-top:5px"/></style></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="py"/>
					</defaultStyles>
				</style>
			</pageBody>
			<pageFooter>
				<contents>
					<promptButton type="cancel">
						<contents/>
						<style>
							<defaultStyles>
								<defaultStyle refStyle="bp"/>
							</defaultStyles>
						<CSS value="background-color:silver"/></style>
					</promptButton>
					<promptButton type="back">
						<contents/>
						<style>
							<defaultStyles>
								<defaultStyle refStyle="bp"/>
							</defaultStyles>
						<CSS value="background-color:silver"/></style>
					</promptButton>
					<promptButton type="next">
						<contents/>
						<style>
							<defaultStyles>
								<defaultStyle refStyle="bp"/>
							</defaultStyles>
						<CSS value="background-color:silver"/></style>
					</promptButton>
					<promptButton type="finish">
						<contents/>
						<style>
							<defaultStyles>
								<defaultStyle refStyle="bp"/>
							</defaultStyles>
						<CSS value="background-color:silver"/></style>
					</promptButton>
				</contents>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="fp"/>
					</defaultStyles>
				</style>
			</pageFooter>
			<style>
				<defaultStyles>
					<defaultStyle refStyle="pp"/>
				</defaultStyles>
			</style>
		</page></promptPages></layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>6.6 ESX Subscriptions Impact with History - ETL</reportName><queries><query name="Report ETL - Current">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
dwh_custom.esx_subscription_history_fact.clustername as 'Cluster Name',
SUBSTRING_INDEX(dwh_custom.esx_subscription_history_fact.ESXhost,'.',1) as 'ESX Host',
dwh_custom.esx_subscription_history_fact.memoryGB as 'Memory GB',
dwh_custom.esx_subscription_history_fact.CPUCount as 'CPU Count',
dwh_custom.esx_subscription_history_fact.AllocatedCPUCount as 'Allocated CPU Count',
dwh_custom.esx_subscription_history_fact.AllocatedMemoryGB as 'Allocated Memory GB',
dwh_custom.esx_subscription_history_fact.memorySubscriptionPercent as 'Memory Subscription %',
dwh_custom.esx_subscription_history_fact.CPUSubscriptionPercent as 'CPU Subscription %',
dwh_custom.esx_subscription_history_fact.provisionedTB as 'Provisioned (TB)',
dwh_custom.esx_subscription_history_fact.usedTB as 'Used (TB)',
dwh_custom.esx_subscription_history_fact.fulldate as 'Date'

FROM dwh_custom.esx_subscription_history_fact


WHERE dwh_custom.esx_subscription_history_fact.fulldate &gt;= (SELECT MAX(dwh_custom.esx_subscription_history_fact.fulldate) 
FROM dwh_custom.esx_subscription_history_fact) - INTERVAL 0 DAY


</sqlText>
		<mdProjectedItems><mdProjectedItem name="Cluster Name"/><mdProjectedItem name="ESX Host"/><mdProjectedItem name="Memory GB"/><mdProjectedItem name="CPU Count"/><mdProjectedItem name="Allocated CPU Count"/><mdProjectedItem name="Allocated Memory GB"/><mdProjectedItem name="Memory Subscription %"/><mdProjectedItem name="CPU Subscription %"/><mdProjectedItem name="Provisioned (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Cluster Name"><expression>[SQL3].[Cluster Name]</expression></dataItem><dataItem name="ESX Host"><expression>[SQL3].[ESX Host]</expression></dataItem><dataItem name="Memory GB"><expression>[SQL3].[Memory GB]</expression></dataItem><dataItem name="CPU Count" aggregate="total"><expression>[SQL3].[CPU Count]</expression></dataItem><dataItem name="Allocated CPU Count" aggregate="total"><expression>[SQL3].[Allocated CPU Count]</expression></dataItem><dataItem name="Allocated Memory GB" aggregate="total"><expression>[SQL3].[Allocated Memory GB]</expression></dataItem><dataItem name="Memory Subscription %"><expression>[SQL3].[Memory Subscription %]</expression></dataItem><dataItem name="CPU Subscription %"><expression>[SQL3].[CPU Subscription %]</expression></dataItem><dataItem name="Provisioned (TB)"><expression>[SQL3].[Provisioned (TB)]</expression></dataItem><dataItem name="Used (TB)"><expression>[SQL3].[Used (TB)]</expression></dataItem><dataItem name="Date"><expression>[SQL3].[Date]</expression></dataItem><dataItem name="Max Date"><expression>maximum([Date] for report)</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[ESX Host] in ?sESX?</filterExpression></detailFilter></detailFilters></query><query name="Vol Perf">
			<source>
				
			<sqlQuery name="SQL9" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT *
FROM
(

SELECT
SUBSTRING_INDEX(dwh_performance.volume_dimension.name,':',-1) as 'pVolume',
dwh_performance.volume_daily_performance_fact.totaliops as 'totaliops',
dwh_performance.volume_daily_performance_fact.totalresponsetime as 'latency'

FROM dwh_performance.volume_daily_performance_fact
JOIN dwh_performance.volume_dimension
ON dwh_performance.volume_dimension.tk=dwh_performance.volume_daily_performance_fact.volumetk
JOIN dwh_performance.date_dimension
On dwh_performance.date_dimension.tk=dwh_performance.volume_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN dwh_performance.volume_daily_performance_fact 
ON dwh_performance.volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 15 DAY

GROUP BY dwh_performance.volume_dimension.id

UNION

SELECT
dwh_performance.internal_volume_dimension.name as 'Volume',
dwh_performance.internal_volume_daily_performance_fact.totaliops as 'totaliops',
dwh_performance.internal_volume_daily_performance_fact.totalresponsetime as 'latency'

FROM dwh_performance.internal_volume_daily_performance_fact
JOIN dwh_performance.internal_volume_dimension
ON dwh_performance.internal_volume_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.internalvolumetk
JOIN dwh_performance.date_dimension
On dwh_performance.date_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact 
ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 15 DAY

GROUP BY dwh_performance.internal_volume_dimension.id ) perf

JOIN

( 

SELECT DISTINCT
SUBSTRING_INDEX(dwh_inventory.host.name,'.',1) as 'ESX Server',
dwh_inventory.hv_data_store.name as 'Data Store',
dwh_inventory.hv_data_store.capacityMB/1024 as 'Capacity (GB)',
dwh_inventory.hv_data_store.provisionedcapacityMB/1024 as 'Provisioned (GB)',
dwh_inventory.hv_data_store.usedcapacityMB/1024 as 'Used (GB)',
dwh_inventory.storage.name as 'Storage',
COUNT(dwh_inventory.volume.id) as 'LUN Count',
COUNT(dwh_inventory.internal_volume.id) as 'Flexvol Count',
IFNULL(SUBSTRING_INDEX(dwh_inventory.volume.name,':',-1),dwh_inventory.internal_volume.name) as 'Volume',
IFNULL(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024,dwh_inventory.volume.capacityMB/1024) as 'Capacity GB'



FROM dwh_inventory.hv_virtual_machine
JOIN dwh_inventory.host
ON dwh_inventory.host.id=dwh_inventory.hv_virtual_machine.hostid
JOIN dwh_inventory.hv_data_store
ON dwh_inventory.hv_data_store.id=dwh_inventory.hv_virtual_machine.datastoreid
LEFT JOIN dwh_inventory.hv_data_store_to_volume
ON dwh_inventory.hv_data_store.id=dwh_inventory.hv_data_store_to_volume.datastoreid
LEFT JOIN dwh_inventory.volume
ON dwh_inventory.volume.id=dwh_inventory.hv_data_store_to_volume.volumeid
LEFT JOIN dwh_inventory.hv_data_store_to_internal_volume
ON dwh_inventory.hv_data_store.id=dwh_inventory.hv_data_store_to_internal_volume.datastoreid
LEFT JOIN dwh_inventory.internal_volume
ON dwh_inventory.internal_volume.id=dwh_inventory.hv_data_store_to_internal_volume.internalvolumeid
LEFT JOIN dwh_inventory.storage
ON dwh_inventory.storage.id=dwh_inventory.hv_data_store_to_volume.storageid OR dwh_inventory.storage.id=dwh_inventory.hv_data_store_to_internal_volume.storageid

GROUP BY dwh_inventory.volume.id, dwh_inventory.host.id, dwh_inventory.hv_data_store.id ) cap ON cap.Volume=perf.pVolume </sqlText>
		<mdProjectedItems><mdProjectedItem name="pVolume"/><mdProjectedItem name="totaliops"/><mdProjectedItem name="latency"/><mdProjectedItem name="ESX Server"/><mdProjectedItem name="Data Store"/><mdProjectedItem name="Capacity (GB)"/><mdProjectedItem name="Provisioned (GB)"/><mdProjectedItem name="Used (GB)"/><mdProjectedItem name="Storage"/><mdProjectedItem name="LUN Count"/><mdProjectedItem name="Flexvol Count"/><mdProjectedItem name="Volume"/><mdProjectedItem name="Capacity GB"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Volume"><expression>[SQL9].[Volume]</expression></dataItem><dataItem name="totaliops" aggregate="total"><expression>[SQL9].[totaliops]</expression></dataItem><dataItem name="latency" aggregate="average"><expression>[SQL9].[latency]</expression></dataItem><dataItem name="ESX Server"><expression>[SQL9].[ESX Server]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[ESX Server] in ?sESX?</filterExpression></detailFilter></detailFilters></query><query name="VM Perf">
			<source>
				
			<sqlQuery name="SQL8" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT

SUBSTRING_INDEX(dwh_custom.VMperf.ESXHost,'.',1) as ESXHost,
dwh_custom.VMperf.VMGuest,
dwh_custom.VMperf.totaliops,
dwh_custom.VMperf.peakiops,
dwh_custom.VMperf.latency,
dwh_custom.VMperf.peaklatency,
dwh_custom.VMperf.AverageCPUUtilization,
dwh_custom.VMperf.PeakCPUUtilization,
dwh_custom.VMperf.AverageMemoryUtilization,
dwh_custom.VMperf.PeakMemoryUtilization,
dwh_custom.VMperf.Processors,
dwh_custom.VMperf.Time

FROM dwh_custom.VMperf</sqlText>
		<mdProjectedItems><mdProjectedItem name="ESXHost"/><mdProjectedItem name="VMGuest"/><mdProjectedItem name="totaliops"/><mdProjectedItem name="peakiops"/><mdProjectedItem name="latency"/><mdProjectedItem name="peaklatency"/><mdProjectedItem name="AverageCPUUtilization"/><mdProjectedItem name="PeakCPUUtilization"/><mdProjectedItem name="AverageMemoryUtilization"/><mdProjectedItem name="PeakMemoryUtilization"/><mdProjectedItem name="Processors"/><mdProjectedItem name="Time"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="ESXHost"><expression>[SQL8].[ESXHost]</expression></dataItem><dataItem name="VMGuest"><expression>[SQL8].[VMGuest]</expression></dataItem><dataItem name="totaliops"><expression>[SQL8].[totaliops]</expression></dataItem><dataItem name="peakiops"><expression>[SQL8].[peakiops]</expression></dataItem><dataItem name="latency" aggregate="average"><expression>[SQL8].[latency]</expression></dataItem><dataItem name="peaklatency"><expression>[SQL8].[peaklatency]</expression></dataItem><dataItem name="AverageCPUUtilization" aggregate="average"><expression>[SQL8].[AverageCPUUtilization]</expression></dataItem><dataItem name="AverageMemoryUtilization"><expression>[SQL8].[AverageMemoryUtilization]</expression></dataItem><dataItem name="PeakMemoryUtilization"><expression>[SQL8].[PeakMemoryUtilization]</expression></dataItem><dataItem name="Processors" rollupAggregate="maximum"><expression>[SQL8].[Processors]</expression></dataItem><dataItem name="Time"><expression>[SQL8].[Time]</expression></dataItem><dataItem name="VM Count"><expression>count(distinct [VMGuest] for [ESXHost])</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[ESXHost] in ?sESX?</filterExpression></detailFilter></detailFilters></query><query name="Report ETL">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
dwh_custom.esx_subscription_history_fact.clustername as 'Cluster Name',
SUBSTRING_INDEX(dwh_custom.esx_subscription_history_fact.ESXhost,'.',1) as 'ESX Host',
dwh_custom.esx_subscription_history_fact.memoryGB as 'Memory GB',
dwh_custom.esx_subscription_history_fact.CPUCount as 'CPU Count',
dwh_custom.esx_subscription_history_fact.AllocatedCPUCount as 'Allocated CPU Count',
dwh_custom.esx_subscription_history_fact.AllocatedMemoryGB as 'Allocated Memory GB',
dwh_custom.esx_subscription_history_fact.memorySubscriptionPercent as 'Memory Subscription %',
dwh_custom.esx_subscription_history_fact.CPUSubscriptionPercent as 'CPU Subscription %',
dwh_custom.esx_subscription_history_fact.provisionedTB as 'Provisioned (TB)',
dwh_custom.esx_subscription_history_fact.usedTB as 'Used (TB)',
dwh_custom.esx_subscription_history_fact.fulldate as 'Date'

FROM dwh_custom.esx_subscription_history_fact

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Cluster Name"/><mdProjectedItem name="ESX Host"/><mdProjectedItem name="Memory GB"/><mdProjectedItem name="CPU Count"/><mdProjectedItem name="Allocated CPU Count"/><mdProjectedItem name="Allocated Memory GB"/><mdProjectedItem name="Memory Subscription %"/><mdProjectedItem name="CPU Subscription %"/><mdProjectedItem name="Provisioned (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Cluster Name"><expression>[SQL4].[Cluster Name]</expression></dataItem><dataItem name="ESX Host"><expression>[SQL4].[ESX Host]</expression></dataItem><dataItem name="Memory GB"><expression>[SQL4].[Memory GB]</expression></dataItem><dataItem name="CPU Count"><expression>[SQL4].[CPU Count]</expression></dataItem><dataItem name="Allocated CPU Count"><expression>[SQL4].[Allocated CPU Count]</expression></dataItem><dataItem name="Allocated Memory GB"><expression>[SQL4].[Allocated Memory GB]</expression></dataItem><dataItem name="Memory Subscription %" rollupAggregate="total"><expression>[SQL4].[Allocated Memory GB]/[SQL4].[Memory GB]</expression></dataItem><dataItem name="CPU Subscription %" rollupAggregate="total"><expression>[SQL4].[Allocated CPU Count]/[SQL4].[CPU Count]</expression></dataItem><dataItem name="Provisioned (TB)"><expression>[SQL4].[Provisioned (TB)]</expression></dataItem><dataItem name="Used (TB)"><expression>[SQL4].[Used (TB)]</expression></dataItem><dataItem name="Date"><expression>[SQL4].[Date]</expression></dataItem><dataItem name="Max Date"><expression>maximum([Date] for report)</expression></dataItem><dataItem name="CPU Subscription % Latest" aggregate="maximum"><expression>if([Max Date]=[Date]) THEN ([CPU Subscription %]) ELSE (0)</expression></dataItem><dataItem name="Memory Subscription % Latest" aggregate="maximum"><expression>if([Max Date]=[Date]) THEN ([Memory Subscription %]) ELSE (0)</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[ESX Host] in ?sESX?</filterExpression></detailFilter></detailFilters></query><query name="ESX Perf ETL">
			<source>
				
			<sqlQuery name="SQL2" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT

dwh_custom.ESXperf.Cluster,
SUBSTRING_INDEX(dwh_custom.ESXperf.ESXHost,'.',1) as ESXHost,
dwh_custom.ESXperf.totaliops,
dwh_custom.ESXperf.peakiops,
dwh_custom.ESXperf.latency,
dwh_custom.ESXperf.peaklatency,
dwh_custom.ESXperf.AverageCPUUtilization,
dwh_custom.ESXperf.PeakCPUUtilization,
dwh_custom.ESXperf.AverageMemoryUtilization,
dwh_custom.ESXperf.PeakMemoryUtilization,
dwh_custom.ESXperf.time

FROM dwh_custom.ESXperf</sqlText>
		<mdProjectedItems><mdProjectedItem name="Cluster"/><mdProjectedItem name="ESXHost"/><mdProjectedItem name="totaliops"/><mdProjectedItem name="peakiops"/><mdProjectedItem name="latency"/><mdProjectedItem name="peaklatency"/><mdProjectedItem name="AverageCPUUtilization"/><mdProjectedItem name="PeakCPUUtilization"/><mdProjectedItem name="AverageMemoryUtilization"/><mdProjectedItem name="PeakMemoryUtilization"/><mdProjectedItem name="time"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Cluster"><expression>[SQL2].[Cluster]</expression></dataItem><dataItem name="ESXHost"><expression>[SQL2].[ESXHost]</expression></dataItem><dataItem name="totaliops" rollupAggregate="total"><expression>[SQL2].[totaliops]</expression></dataItem><dataItem name="peakiops"><expression>[SQL2].[peakiops]</expression></dataItem><dataItem name="latency" rollupAggregate="average"><expression>[SQL2].[latency]</expression></dataItem><dataItem name="peaklatency"><expression>[SQL2].[peaklatency]</expression></dataItem><dataItem name="AverageCPUUtilization" rollupAggregate="average"><expression>[SQL2].[AverageCPUUtilization]</expression></dataItem><dataItem name="PeakCPUUtilization"><expression>[SQL2].[PeakCPUUtilization]</expression></dataItem><dataItem name="AverageMemoryUtilization" rollupAggregate="average"><expression>[SQL2].[AverageMemoryUtilization]</expression></dataItem><dataItem name="PeakMemoryUtilization"><expression>[SQL2].[PeakMemoryUtilization]</expression></dataItem><dataItem name="time"><expression>[SQL2].[time]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[ESXHost] in ?sESX?</filterExpression></detailFilter></detailFilters></query><query name="Top Consumers CPU - VM Guests">
			<source>
				
			<sqlQuery name="SQL5" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
SUBSTRING_INDEX(dwh_inventory.host.name,'.',1) as 'ESX Server',
dwh_inventory.hv_virtual_machine.name as 'VM Guest',
dwh_inventory.hv_virtual_machine.processors as 'CPUs',
dwh_inventory.hv_virtual_machine.memory as 'Memory MB',
dwh_inventory.hv_virtual_machine.provisionedCapacityMB/1024 as 'Provisioned GB',
dwh_inventory.hv_virtual_machine.usedCapacityMB/1024 as 'Used GB'

FROM dwh_inventory.hv_virtual_machine
JOIN dwh_inventory.host
ON dwh_inventory.host.id=dwh_inventory.hv_virtual_machine.hostid

GROUP BY dwh_inventory.host.id, dwh_inventory.hv_virtual_machine.id

</sqlText>
		<mdProjectedItems><mdProjectedItem name="ESX Server"/><mdProjectedItem name="VM Guest"/><mdProjectedItem name="CPUs"/><mdProjectedItem name="Memory MB"/><mdProjectedItem name="Provisioned GB"/><mdProjectedItem name="Used GB"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="ESX Server"><expression>[SQL5].[ESX Server]</expression></dataItem><dataItem name="VM Guest"><expression>[SQL5].[VM Guest]</expression></dataItem><dataItem name="CPUs" rollupAggregate="total"><expression>[SQL5].[CPUs]</expression></dataItem><dataItem name="Memory MB"><expression>[SQL5].[Memory MB]</expression></dataItem><dataItem name="Provisioned GB"><expression>[SQL5].[Provisioned GB]</expression></dataItem><dataItem name="Used GB"><expression>[SQL5].[Used GB]</expression></dataItem><dataItem name="VM Count"><expression>count([VM Guest] for [ESX Server])</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[ESX Server] in ?sESX?</filterExpression></detailFilter></detailFilters></query><query name="ESX Capacities">
			<source>
				
			<sqlQuery name="SQL7" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT DISTINCT
SUBSTRING_INDEX(dwh_inventory.host.name,'.',1) as 'ESX Server',
dwh_inventory.hv_data_store.name as 'Data Store',
dwh_inventory.hv_data_store.capacityMB/1024 as 'Capacity (GB)',
dwh_inventory.hv_data_store.provisionedcapacityMB/1024 as 'Provisioned (GB)',
dwh_inventory.hv_data_store.usedcapacityMB/1024 as 'Used (GB)',
dwh_inventory.storage.name as 'Storage',
COUNT(dwh_inventory.volume.id) as 'LUN Count',
COUNT(dwh_inventory.internal_volume.id) as 'Flexvol Count',
IFNULL(SUBSTRING_INDEX(dwh_inventory.volume.name,':',-1),dwh_inventory.internal_volume.name) as 'Volume',
IFNULL(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024,dwh_inventory.volume.capacityMB/1024) as 'Capacity GB'



FROM dwh_inventory.hv_virtual_machine
JOIN dwh_inventory.host
ON dwh_inventory.host.id=dwh_inventory.hv_virtual_machine.hostid
JOIN dwh_inventory.hv_data_store
ON dwh_inventory.hv_data_store.id=dwh_inventory.hv_virtual_machine.datastoreid
LEFT JOIN dwh_inventory.hv_data_store_to_volume
ON dwh_inventory.hv_data_store.id=dwh_inventory.hv_data_store_to_volume.datastoreid
LEFT JOIN dwh_inventory.volume
ON dwh_inventory.volume.id=dwh_inventory.hv_data_store_to_volume.volumeid
LEFT JOIN dwh_inventory.hv_data_store_to_internal_volume
ON dwh_inventory.hv_data_store.id=dwh_inventory.hv_data_store_to_internal_volume.datastoreid
LEFT JOIN dwh_inventory.internal_volume
ON dwh_inventory.internal_volume.id=dwh_inventory.hv_data_store_to_internal_volume.internalvolumeid
LEFT JOIN dwh_inventory.storage
ON dwh_inventory.storage.id=dwh_inventory.hv_data_store_to_volume.storageid OR dwh_inventory.storage.id=dwh_inventory.hv_data_store_to_internal_volume.storageid

GROUP BY dwh_inventory.host.id, dwh_inventory.hv_data_store.id</sqlText>
		<mdProjectedItems><mdProjectedItem name="ESX Server"/><mdProjectedItem name="Data Store"/><mdProjectedItem name="Capacity (GB)"/><mdProjectedItem name="Provisioned (GB)"/><mdProjectedItem name="Used (GB)"/><mdProjectedItem name="Storage"/><mdProjectedItem name="LUN Count"/><mdProjectedItem name="Flexvol Count"/><mdProjectedItem name="Volume"/><mdProjectedItem name="Capacity GB"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="ESX Server"><expression>[SQL7].[ESX Server]</expression></dataItem><dataItem name="Data Store"><expression>[SQL7].[Data Store]</expression></dataItem><dataItem name="Capacity (GB)" aggregate="total"><expression>[SQL7].[Capacity (GB)]</expression></dataItem><dataItem name="Provisioned (GB)" aggregate="total"><expression>[SQL7].[Provisioned (GB)]</expression></dataItem><dataItem name="Used (GB)" aggregate="total"><expression>[SQL7].[Used (GB)]</expression></dataItem><dataItem name="Storage"><expression>[SQL7].[Storage]</expression></dataItem><dataItem name="LUN Count" aggregate="total"><expression>[SQL7].[LUN Count]</expression></dataItem><dataItem name="Flexvol Count" aggregate="total"><expression>[SQL7].[Flexvol Count]</expression></dataItem><dataItem name="Volume"><expression>[SQL7].[Volume]</expression></dataItem><dataItem name="Capacity GB" label="Volume Capacity GB"><expression>[SQL7].[Capacity GB]</expression></dataItem><dataItem name="% Used" label="Used %"><expression>[Used (GB)]/[Capacity (GB)]</expression></dataItem><dataItem name="Thin Subscribed%"><expression>[Provisioned (GB)]/[Capacity (GB)]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[ESX Server] in ?sESX?</filterExpression></detailFilter></detailFilters></query><query name="sESX Prompt">
			<source>
				
			<sqlQuery name="SQL6" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
SUBSTRING_INDEX(dwh_inventory.host.name,'.',1) as 'ESX Server',
dwh_inventory.host.name as 'Host Name',
dwh_inventory.host.ip as 'Host IP',
IF(dwh_inventory.host.name=dwh_inventory.host.ip, 'True', 'False') as 'IP Status'

FROM dwh_inventory.hv_virtual_machine
JOIN dwh_inventory.host
ON dwh_inventory.host.id=dwh_inventory.hv_virtual_machine.hostid

WHERE dwh_inventory.host.name&lt;&gt;dwh_inventory.host.ip

GROUP BY dwh_inventory.host.id</sqlText>
		<mdProjectedItems><mdProjectedItem name="ESX Server"/><mdProjectedItem name="Host Name"/><mdProjectedItem name="Host IP"/><mdProjectedItem name="IP Status"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="ESX Server"><expression>[SQL6].[ESX Server]</expression></dataItem><dataItem name="Host IP"><expression>[SQL6].[Host IP]</expression></dataItem><dataItem name="Host Name"><expression>[SQL6].[Host Name]</expression></dataItem><dataItem name="IP Status"><expression>[SQL6].[IP Status]</expression></dataItem></selection>
		</query></queries><namedConditionalStyles><advancedConditionalStyle name="DataStoreOverProvisioned"><styleCases><styleCase><style><CSS value="background-color:#F86464;color:black;font-weight:bold"/></style><reportCondition>[Report].[VM Provisioned Capacity TB]&gt;[Report].[Data Store Allocated TB]</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle><advancedConditionalStyle name="CPUOverSubscribed"><styleCases><styleCase><style><CSS value="background-color:white;color:maroon;font-weight:bold"/></style><reportCondition>[Report].[CPU Subscription %]&gt;1</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle><advancedConditionalStyle name="MemoryOverSubscribed"><styleCases><styleCase><style><CSS value="background-color:white;font-weight:bold;color:maroon"/></style><reportCondition>[Report].[Memory Subscription %]&gt;1</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle><advancedConditionalStyle name="ESXCPUUtilization"><styleCases><styleCase><style><CSS value="background-color:#F86464;color:black"/></style><reportCondition>[Report].[ESX CPU Utilization %]&gt;65</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle><advancedConditionalStyle name="ESXLatency"><styleCases><styleCase><style><CSS value="background-color:#F86464;color:black"/></style><reportCondition>[Report].[ESX Latency (ms)]&gt;25</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle><advancedConditionalStyle name="% Data Store Used"><styleCases><styleCase><style><CSS value="color:#FF6666;font-weight:bold"/></style><reportCondition>[ESX Capacities].[% Used]&gt;.8</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle><advancedConditionalStyle name="Thin Subscribed %"><styleCases><styleCase><style><CSS value="color:#FF6600;font-weight:bold"/></style><reportCondition>[ESX Capacities].[Thin Subscribed%]&gt;1</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle><advancedConditionalStyle name="List-MemorySubscription"><styleCases><styleCase><style><CSS value="color:#FF6666;font-weight:bold"/></style><reportCondition>[Report ETL - Current].[Memory Subscription %]&gt;1</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle><advancedConditionalStyle name="List-CPUSubscription"><styleCases><styleCase><style><CSS value="color:#FF6666;font-weight:bold"/></style><reportCondition>[Report ETL - Current].[CPU Subscription %]&gt;1</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 1"><styleCases><styleCase><style><CSS value="color:#FF6666"/></style><reportCondition>[Report ETL].[CPU Subscription % Latest]&gt;1</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 2"><styleCases><styleCase><style><CSS value="color:#FF6666"/></style><reportCondition>[Report ETL].[Memory Subscription % Latest]&gt;1</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle></namedConditionalStyles><classStyles><classStyle name="pl"><CSS value="color:#333333"/></classStyle></classStyles><reportVariables><reportVariable type="boolean" name="vmCountMoreThan30">
			<reportExpression>[VM Perf].[VM Count]&gt;30</reportExpression>
			<variableValues>
				<variableValue value="1"/>
			</variableValues>
		</reportVariable><reportVariable type="boolean" name="VMCountLessThan=30">
			<reportExpression>[VM Perf].[VM Count]&lt;=30</reportExpression>
			<variableValues>
				<variableValue value="1"/>
			</variableValues>
		</reportVariable></reportVariables></report>